Model Table CURRENCY

Attributes

Attribute Description (where applicable)
Company Code
Conversion FactorRepresents the conversion factor (CONVERSION_FACTOR)  for the currency.
Currency CodeRepresents the CODE of the dimension, e.g. the currency code.
Currency Code DescRepresents the Currency Code Description
EMU Currency From DateRepresents the EMU_CURRENCY_FROM_DATE, i.e. that date from where the currency was converted to EUR.
ID
InvertedRepresents INVERTED "flag", i.e. if the curency code by default supports rates in inverted quotation.

USED BY MODEL(S)

Model Name
Cash Planning

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
CURRENCYDIM_CURRENCY_CODE_TMDIM_CURRENCY_CODE_BIDIM_CURRENCY_CODEOn Line